2015-10-19 - 22514 - Enhancement - 2017 Fiscal period update #CrystalReportsSupport
SPECIFICATIONS
22514 - OSA100 - 2017 Fiscal period update
Purpose
Need to update OSA100 in Global and EMEA folder for not displaying the dates in 2017, those reports should be updated in order to access the fiscal period via the existing BEx queries.
Admin Info
Purpose
|
Need to update OSA100 in Global and EMEA folder for not displaying the dates in 2017, those reports should be updated in order to access the fiscal period via the existing BEx queries.
|
Requested By
|
Mark Harris
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
10/19/2015
|
Spec QA by
|
Uday Kumar P
|
Objects
|
OSA100 Global & Regional BEx Queries.
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
04
|
2
|
Documentation
|
04
|
3
|
Development/ Config
|
20
|
4
|
Unit test in DEV
|
04
|
5
|
Unit test in QUA
|
08
|
|
TOTAL
|
40
|
References
Prior Tickets
None
Documents
The list of BEx queries used in OSA100 Global & Regional BEx Queries is attached here for reference:
OSA 100 Global & Regional BEx Queries.txt
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
001
|
Add Fiscal Year & Fiscal period in BEx queries used in OSA100.
|
Saravanan Lakshmanan
|
10/19/2015
|
Request through Email.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Need to update OSA100 in Global and EMEA folder for not displaying the dates in 2017, those reports should be updated in order to access the fiscal period via the existing BEx queries.
In Scope:
OSA100 Global & Regional BEx Queries.
Out of Scope:
Other BEx Queries.
Solution Summary
1. Need to add Fiscal Year & Posting period infoobjects to OSA100 Global & Regional BEx Queries.
2. Need to maintain Characteristic properties of newly added characteristics as per NEC Standard Checklist.
3. Need to create a new transport request & collect all the necessary BEx Query changes.
4. Need to perform unit testing in BPD & after successful testing transport it to BPQ & BPP.
5. Need to update OSA100 reports for Global & Regional versions.
6. Need to develop new logic in crystal report to use newly added fields to display Fiscal Year & Fiscal Period.
7. Excluded the additional japan intercompany customers 1017049,1017054,1017055,1017056,1018680,1018681,1018682 and 1018689.
8. Need to validate with BEx Queries and after successful
validation, promote reports into BI Production.
Solution Details
1. Need to add Fiscal Year(0FISCYEAR) & Posting period (0FISCPER3) infoobjects to OSA100 Global & Regional BEx Queries.
2. Need to maintain Characteristic properties of newly added characteristics as per NEC Standard Checklist.
3. Need to create a new transport request & collect all the necessary BEx Query changes.
4. Need to perform unit testing in BPD & after successful testing transport it to BPQ & BPP.
5. Need to update OSA100 reports for Global & Regional versions.
6. Need to develop new logic in crystal report to use newly added fields to display Fiscal Year & Fiscal Period.
7. Excluded the additional japan intercompany customers 1017049,1017054,1017055,1017056,1018680,1018681,1018682 and 1018689.
8. Need to validate with BEx Queries and after successful validation, promote reports into BI Production.
Issues
None